Spreadsheets can be used for more than just creating tables and charts and
summarizing data. Instead of just storing, summarizing, and formatting data, a financial
model is used for analysis. Spreadsheets are now commonly used for creating complex
mathematical models. In this course, we will explain how to build financial models in
Excel by provides instructions, not templates. We will learn to develop value-added skills
in spreadsheet modeling of financial applications.
This is a course emphasizing on learning by doing. What you learn from this course
will be very important for your career. The major software used in this course is Excel.
We are going to use Excel as a tool to solve financial problems. Financial issues to be
covered are capital budgeting, financial statement analysis, portfolio analysis, capital
structure, dividend policy, bond management, option pricing, and option trading strategy.
Excel functions and tools, such as Data Table, Goal seeker, Solver etc. will be used
intensively. Programming a VBA macro is an important task in this course.
After finishing this course, you can put the following statement, “Excel Expert”, on
your resume and get a good job.
Class Schedule
Week Date Contents
1 2016/9/12 The time value of money
2 2016/9/19 Financial ratio analysis
3 2016/9/26 Capital budgeting
4 2016/10/3 Sensitivity analysis, Scenario analysis, Simulation
5 2016/10/10 Holiday, no class
6 2016/10/17 Statistics analysis and matrix operation
7 2016/10/24 Two-asset portfolio analysis
8 2016/10/31 3-asset portfolio analysis : matrix and VBA
9 2016/11/7 Midterm examination
10 2016/11/14 Optimal Capital structure
11 2016/11/21 Dividends Policy and practice
12 2016/11/28 Interest rate models
13 2016/12/5 Bond pricing and risk management
14 2016/12/12 Option pricing: Black-Scholes model, Binominal model
15 2016/12/19 Option trading strategy
16 2016/12/26 Pivot tables & Financial games
17 2017/1/2 Holiday, no class
18 2017/1/9 Final examination
* Students with disability should come to me for appropriate arrangements.
* I reserve the right to change the above contents.